CREATE VIEW [dbo].[vSoaGroupMemberDetailOrganization]
WITH SCHEMABINDING
AS
    SELECT  CAST('ORGRELATIONSHIP-' + [n].[CO_ID] + ':' + [n].[ID] AS VARCHAR(50)) AS [GroupMemberDetailId],
            CAST('ORGRELATIONSHIP-' + [n].[CO_ID] + ':' + [n].[ID] AS VARCHAR(50)) AS [GroupMemberId],
            [n].[ID] AS [PartyId],
            CAST(1 AS BIT) AS [IsActive],
            CAST('ORGRELATIONSHIP:' + [n].[CO_ID] AS VARCHAR(30)) AS [GroupRoleId],
            CAST([n].[TITLE] AS VARCHAR(100)) AS [Title]
      FROM  [dbo].[Name] AS [n]
     WHERE  [n].[CO_ID] != ''


GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupMemberDetailOrganization] ON [dbo].[vSoaGroupMemberDetailOrganization] ([GroupMemberDetailId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberDetailOrganization_GroupMemberId] ON [dbo].[vSoaGroupMemberDetailOrganization] ([GroupMemberId]) ON [PRIMARY]
GO